﻿
IF (EXISTS(SELECT id from sysobjects where id=object_id('usp_GetCandidate')))
	DROP PROCEDURE [dbo].[usp_GetCandidate]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

Create PROCEDURE [dbo].[usp_GetCandidate]
@CandidateId as varchar(50)
AS
SET NOCOUNT ON;
select * from TblCandidate where CandidateId=@CandidateId;